DBMS - Topic Wise Multiple Choice Questions (MCQ)
Database Management System MCQ for Specialist Officer exam freshers interview Practice Multiple Choice DBMS Interview Questions and answer for MNC IT Job SO Exam
11 )
In a relational database a referential integrity constraint can be specified with the help of
primary key
foreign key ✔
secondary key
none of the above
View Solution
12 )
A super key is a set of one or more attributes that, taken collectively, allow us
to identify uniquely an entity in the entity set ✔
to make the key most powerful for faster retrieval
to increase effectiveness of database access
none of the above
View Solution
13 )
4NF is designed to cope with:
Transitive dependency
Join dependency
Multi valued dependency ✔
None of these
View Solution
14 )
Every Boyee-Codd normal form is in
First normal form
Second normal form
Third normal form
All of the above ✔
View Solution
15 )
Which command is used to remove all rows from a table?
Delete
Remove
Truncate ✔
Both [A] and [B]
View Solution